UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zo8Rdj+NOBuWeyQHWV81ebMfUu6rWJX4MnmNZ3eaZ+I='
WHERE
key_id = '45bfe01ed483dca9d554bf91e5e63c893a3a895758a5d6189aa87bf5ab22af1d'
AND (
token = 'Zo8Rdj+NOBuWeyQHWV81ebMfUu6rWJX4MnmNZ3eaZ+I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)