UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tK7J/wbgQcwFol5KEocSuK5YxQMPcTXkT3hF4HrBueQ='
WHERE
key_id = '919e671a537a5b23275e8695ab71bb0c0a6fb1f3678b96d2898bd03935214edf'
AND (
token = 'tK7J/wbgQcwFol5KEocSuK5YxQMPcTXkT3hF4HrBueQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)