UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pcn7ny/AK7gTQ8NixEaBgDoOxY3/4F61OvlGCdnTFg8='
WHERE
key_id = 'cd4f2609b791e10697691554cf9940d15bff2459d52a208b39d6e3a4504ccc81'
AND (
token = 'Pcn7ny/AK7gTQ8NixEaBgDoOxY3/4F61OvlGCdnTFg8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)