UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'apE7IoZh9f6X89FxvmsRN2EF2Y7SHku20gOAUBJaSFA='
WHERE
key_id = 'eb73d8225d4f499f066bea04e02f5f5b7508a47aaf257a301efab49bf33bc23a'
AND (
token = 'apE7IoZh9f6X89FxvmsRN2EF2Y7SHku20gOAUBJaSFA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)