UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hcb7RNE9HvL5egVumu42f7ep2rUDFIwpjHlthFRUpg0='
WHERE
key_id = '2d3d8977e5b57675c87898684f4e2250261e471d424c27eb45f7c842367317ae'
AND (
token = 'Hcb7RNE9HvL5egVumu42f7ep2rUDFIwpjHlthFRUpg0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)