UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NFSME4SwjHhYARtxvetgyxL1o58L5sOdcJvWJ6AkXr8='
WHERE
key_id = 'f238673766081190a2dd70b085d6f84fd41a3e2425b58d7fda8b64bd76ee7718'
AND (
token = 'NFSME4SwjHhYARtxvetgyxL1o58L5sOdcJvWJ6AkXr8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)