UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xBF2DPs+h9j67KThdR6m56DklSOeGVNWOTLqsk9fVVE='
WHERE
key_id = 'f9ec88cf3317ba4363ebe6da2ff82f6b918df4c8e34929c00d5ca410e9272d65'
AND (
token = 'xBF2DPs+h9j67KThdR6m56DklSOeGVNWOTLqsk9fVVE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)