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