UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tVcZqIyPtBqpKhReUDYbV84ne5LN/14Ggf8j6ERcI3E='
WHERE
key_id = 'aeef53abce33731c9caec55e07094b78a464ab11e823ee8d34ac3a300131f4de'
AND (
token = 'tVcZqIyPtBqpKhReUDYbV84ne5LN/14Ggf8j6ERcI3E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)