UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZLn0bXmkIYf7xfbFggqvoGCn7Qw1xnHdqW5N873kOXs='
WHERE
key_id = '713becb367b02704f5f024663a71092658e68a4a6096ebf948081fd48d886e1b'
AND (
token = 'ZLn0bXmkIYf7xfbFggqvoGCn7Qw1xnHdqW5N873kOXs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)