UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UG75B/KBeEW+4RtyptEPr78zdJy+tDsNo3Kha5/0Q00='
WHERE
key_id = '16418ae1a81c5029e83ca39506470976b9908c9e22118d2625177d4ad356436c'
AND (
token = 'UG75B/KBeEW+4RtyptEPr78zdJy+tDsNo3Kha5/0Q00='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)