UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1lBzp+47DL9e/3YdLO9MJl506FiN4qZZO5FrzrghDAo='
WHERE
key_id = '7fe6e81ee04f494059d2081fffb90c4f376a93a356b19acb829a6248a3033571'
AND (
token = '1lBzp+47DL9e/3YdLO9MJl506FiN4qZZO5FrzrghDAo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)