UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A9z7Zzvzmbmf77N2/4Ho0R6z32OOLBH3zXeu3AVJjYA='
WHERE
key_id = '57f0633e681a60628eb027b814c6111a111b3f0de14b7defbece095de2f950ca'
AND (
token = 'A9z7Zzvzmbmf77N2/4Ho0R6z32OOLBH3zXeu3AVJjYA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)