UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CCXymAI6eVtFQAj2ySDl0oBIAV1qAjZ37KkaK1kVyv8='
WHERE
key_id = '624c89cc0cb963ba9cebefd225d44f1a7ca0020ff205b9ea93b2652ee0576027'
AND (
token = 'CCXymAI6eVtFQAj2ySDl0oBIAV1qAjZ37KkaK1kVyv8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)