UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nzNYy/s5LgoGoxBuz8SGCxqxZt+mKr26FjDIgXzIwd8='
WHERE
key_id = 'b197ef5a0f56e272855527c3f5cf4e4a9c4634dffee8b0c5b56b4ea4ad6cdd01'
AND (
token = 'nzNYy/s5LgoGoxBuz8SGCxqxZt+mKr26FjDIgXzIwd8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)