UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8vN4FsZF1eIIJbhlCIVaGi7Sx4mQd0rrUM/Z7E+h48g='
WHERE
key_id = 'd1b6c4096f66350f7328ba72b0d1bc4b56afcdf85f3f4726b1efee7c3a623a24'
AND (
token = '8vN4FsZF1eIIJbhlCIVaGi7Sx4mQd0rrUM/Z7E+h48g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)