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