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