UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LUJHidOYyudI0izqLQsaEqTe3Aw+D86GnWvkcS6maws='
WHERE
key_id = 'cd172744b18d22e36c48833ae4516059b0d0b3282b389753f90194009ac114c8'
AND (
token = 'LUJHidOYyudI0izqLQsaEqTe3Aw+D86GnWvkcS6maws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)