UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gzuWHnCLIA2OhmVz/yCqie1psPiNKnOaYYoUr93Gzw8='
WHERE
key_id = 'ea330dd7c7f42c74dd46d8257ddf8168efe2765ee12f5a391b39db8c4201ffd1'
AND (
token = 'gzuWHnCLIA2OhmVz/yCqie1psPiNKnOaYYoUr93Gzw8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)