UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i7LjAMqZYgGJxxDE4ssObf+VgN+wAOWSRn+iJNDmNP4='
WHERE
key_id = '77db6898487c96a27f7af8569df3f81a8fb06ae04fad54d4336b977ae92be5c7'
AND (
token = 'i7LjAMqZYgGJxxDE4ssObf+VgN+wAOWSRn+iJNDmNP4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)