UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T+eEUjTFlomg9sQIjeWA2+JuLKIRsR8vZU9yfjiIkgA='
WHERE
key_id = 'a89a2dca8c8a2ef4c45c2d5867a9c533d7443043a5c9584d21530965d322042c'
AND (
token = 'T+eEUjTFlomg9sQIjeWA2+JuLKIRsR8vZU9yfjiIkgA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)