UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GIcXMrQPrCei1eym7QSWpE3jbAFaCSHEEqcF0/XewyM='
WHERE
key_id = 'b470b210a3d953d1ad3574b4e290305993c10ff3ec3a8203ec66e228c3eaf97f'
AND (
token = 'GIcXMrQPrCei1eym7QSWpE3jbAFaCSHEEqcF0/XewyM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)