UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yKz05GQbMlHvUtI0Z186BENRqu74A0N9UT5bvxvCeOk='
WHERE
key_id = '3be7fbc7e5ff37f10352a70a614aa70d7dbdca8378811c29b3a521d57f0121e4'
AND (
token = 'yKz05GQbMlHvUtI0Z186BENRqu74A0N9UT5bvxvCeOk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)