UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yn/hPYJOCztI+60pxTdxgYOOn7/dotK1txsPud8Iz2s='
WHERE
key_id = '9c32dcec191330dcf3422bb0845f4d0f8a340ef29cddd2ead4f0ec6c7fad31b7'
AND (
token = 'yn/hPYJOCztI+60pxTdxgYOOn7/dotK1txsPud8Iz2s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)