UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6J8pN5aIoobSm+HwEe3xvCUp4bajcM7F72yJSPQpqc8='
WHERE
key_id = '9b5080a8871b679b71c21ca953193cd1974086f94189fa2648c1dd40df5d8947'
AND (
token = '6J8pN5aIoobSm+HwEe3xvCUp4bajcM7F72yJSPQpqc8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)