UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '24VilJ28X3ODJnmDG/T5yXd+43dSjGgs5FI31kSW6AY='
WHERE
key_id = '77c6c71112d3592fcd18d64388afafbbf7853c75bc4baf8e0d368ba42fe7fa66'
AND (
token = '24VilJ28X3ODJnmDG/T5yXd+43dSjGgs5FI31kSW6AY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)