UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TmWbRMl7mXaCHu6Plg5erZYd8pNE+pnbU4He5tuMW2s='
WHERE
key_id = '916e9c63ef7fb713ad702c1cf09947fd55750404e8bdc141616ca7999e9a6f14'
AND (
token = 'TmWbRMl7mXaCHu6Plg5erZYd8pNE+pnbU4He5tuMW2s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)