UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gIakbPDI12zjacDIRadk+vzBZgSZ0ygiVJ4pp6Bwbho='
WHERE
key_id = '8f1ffd6bbe884b09150f05c1fd321ae13cd78a05910e1dd2cdc3d6fbc32dfb7f'
AND (
token = 'gIakbPDI12zjacDIRadk+vzBZgSZ0ygiVJ4pp6Bwbho='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)