UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mL0KuoI4mcEUS+kqjJhcLj4ubXfPoL20OmaCFtNSmrY='
WHERE
key_id = 'b647d240e8f50570b4a83356354989f3d3851f60303fdf7d5a48c091b39b167a'
AND (
token = 'mL0KuoI4mcEUS+kqjJhcLj4ubXfPoL20OmaCFtNSmrY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)