UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'knMSzTNqlywRim0KqSP7HtHhISMw5dqweWI9j1wLslc='
WHERE
key_id = '8caab1d25f823806314cb5fb0b9706cd53a38cc096ee5e64e47a94a8d5d6b7f0'
AND (
token = 'knMSzTNqlywRim0KqSP7HtHhISMw5dqweWI9j1wLslc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)