UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 't1duu/zuHJZLPPFRbiiS9sOEdUS0yBqjKROzM/qbmaY='
WHERE
key_id = 'f9b4d7c04ea68da4792131bd55b2645d0624fe8feb17b885f498df8eec40e392'
AND (
token = 't1duu/zuHJZLPPFRbiiS9sOEdUS0yBqjKROzM/qbmaY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)