UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S2UCdVS9UxS5wVFdw2QLFg93UNCsHu6N+8fushV8jM0='
WHERE
key_id = 'e5e64528bd7fab25c49ddf41d800eefb17ba8dd8f21cd2465858b5abb19453cc'
AND (
token = 'S2UCdVS9UxS5wVFdw2QLFg93UNCsHu6N+8fushV8jM0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)